package com.atmilan.quartz.model.entity.lavita;

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * Vietti商品sku源映射
 * @Description: 
 * @author Daigb
 * @date 2021-07-02
 */
@Data
@JsonIgnoreProperties(ignoreUnknown = true)
public class LavitaProductSku {


    private String sizeId;
    private String colorId;
    private String productId;

    private String size;
    private String color;

    private Integer stock;
    private String skuCode;
    private Integer lockQty;
    private Integer qtyAvail;
    private Integer IsHide;

    private String storeId;
    private String StoreName;
    private String kuanId;
    private String kuan;
    private String productName;
    private String productUnit;
    private String category;
    private BigDecimal skuPrice;
    private String qtyMax;
    private String qtyMin;
    private String qtyCur;
    private String qtyIn;
    private String qtyIntr;

    private Date createTime;

   /* CREATE TABLE `lavita_product_sku` (
            `id` bigint(20) NOT NULL AUTO_INCREMENT,
            `product_id` varchar(64) DEFAULT NULL COMMENT '商品id',
            `client_product_id` varchar(64) DEFAULT NULL COMMENT '原始产品id',

            `size_id` varchar(255) DEFAULT NULL COMMENT '尺码id',
            `color_id` varchar(255) DEFAULT NULL COMMENT '颜色id',
            `size` varchar(255) DEFAULT NULL COMMENT '尺码',
            `color` varchar(255) DEFAULT NULL COMMENT '颜色',
            `stock` int(8) DEFAULT NULL COMMENT '库存',
            `sku_code` varchar(255) DEFAULT NULL COMMENT 'skucode',
            `lock_qty` int(8) DEFAULT NULL COMMENT '锁定库存',
            `qty_avail` int(8) DEFAULT NULL COMMENT '可用库存',
            `is_hide` tinyint(1) DEFAULT NULL COMMENT '是否隐藏',
            `store_id` varchar(255) DEFAULT NULL COMMENT '厂库id',
            `store_name` varchar(255) DEFAULT NULL COMMENT '仓库名称',
            `kuan_id` varchar(255) DEFAULT NULL COMMENT '款id',
            `kuan` varchar(255) DEFAULT NULL COMMENT '款',
            `product_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
            `product_unit` varchar(255) DEFAULT NULL COMMENT '商品单位',
            `category` varchar(255) DEFAULT NULL COMMENT '类别',
            `sku_price` decimal(10,2) DEFAULT NULL COMMENT 'sku价格',
            `qty_max` int(8) DEFAULT NULL COMMENT '库存上限',
            `qty_min` int(8) DEFAULT NULL COMMENT '下线',
            `qty_cur` int(8) DEFAULT NULL COMMENT '当前库存',
            `qty_in` int(8) DEFAULT NULL COMMENT '采购入库数量',
            `qty_intr` int(8) DEFAULT NULL COMMENT '在途数量',

            `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='07-Lavita商品sku源数据表';*/

}
